package pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class WlCommodityInventoryRecordExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public WlCommodityInventoryRecordExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCommodityidIsNull() {
            addCriterion("commodityId is null");
            return (Criteria) this;
        }

        public Criteria andCommodityidIsNotNull() {
            addCriterion("commodityId is not null");
            return (Criteria) this;
        }

        public Criteria andCommodityidEqualTo(String value) {
            addCriterion("commodityId =", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidNotEqualTo(String value) {
            addCriterion("commodityId <>", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidGreaterThan(String value) {
            addCriterion("commodityId >", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidGreaterThanOrEqualTo(String value) {
            addCriterion("commodityId >=", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidLessThan(String value) {
            addCriterion("commodityId <", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidLessThanOrEqualTo(String value) {
            addCriterion("commodityId <=", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidLike(String value) {
            addCriterion("commodityId like", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidNotLike(String value) {
            addCriterion("commodityId not like", value, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidIn(List<String> values) {
            addCriterion("commodityId in", values, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidNotIn(List<String> values) {
            addCriterion("commodityId not in", values, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidBetween(String value1, String value2) {
            addCriterion("commodityId between", value1, value2, "commodityid");
            return (Criteria) this;
        }

        public Criteria andCommodityidNotBetween(String value1, String value2) {
            addCriterion("commodityId not between", value1, value2, "commodityid");
            return (Criteria) this;
        }

        public Criteria andInventoryidIsNull() {
            addCriterion("inventoryId is null");
            return (Criteria) this;
        }

        public Criteria andInventoryidIsNotNull() {
            addCriterion("inventoryId is not null");
            return (Criteria) this;
        }

        public Criteria andInventoryidEqualTo(String value) {
            addCriterion("inventoryId =", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidNotEqualTo(String value) {
            addCriterion("inventoryId <>", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidGreaterThan(String value) {
            addCriterion("inventoryId >", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidGreaterThanOrEqualTo(String value) {
            addCriterion("inventoryId >=", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidLessThan(String value) {
            addCriterion("inventoryId <", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidLessThanOrEqualTo(String value) {
            addCriterion("inventoryId <=", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidLike(String value) {
            addCriterion("inventoryId like", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidNotLike(String value) {
            addCriterion("inventoryId not like", value, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidIn(List<String> values) {
            addCriterion("inventoryId in", values, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidNotIn(List<String> values) {
            addCriterion("inventoryId not in", values, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidBetween(String value1, String value2) {
            addCriterion("inventoryId between", value1, value2, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andInventoryidNotBetween(String value1, String value2) {
            addCriterion("inventoryId not between", value1, value2, "inventoryid");
            return (Criteria) this;
        }

        public Criteria andPropertyIsNull() {
            addCriterion("property is null");
            return (Criteria) this;
        }

        public Criteria andPropertyIsNotNull() {
            addCriterion("property is not null");
            return (Criteria) this;
        }

        public Criteria andPropertyEqualTo(String value) {
            addCriterion("property =", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotEqualTo(String value) {
            addCriterion("property <>", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyGreaterThan(String value) {
            addCriterion("property >", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyGreaterThanOrEqualTo(String value) {
            addCriterion("property >=", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyLessThan(String value) {
            addCriterion("property <", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyLessThanOrEqualTo(String value) {
            addCriterion("property <=", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyLike(String value) {
            addCriterion("property like", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotLike(String value) {
            addCriterion("property not like", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyIn(List<String> values) {
            addCriterion("property in", values, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotIn(List<String> values) {
            addCriterion("property not in", values, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyBetween(String value1, String value2) {
            addCriterion("property between", value1, value2, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotBetween(String value1, String value2) {
            addCriterion("property not between", value1, value2, "property");
            return (Criteria) this;
        }

        public Criteria andOperateplatformIsNull() {
            addCriterion("operatePlatform is null");
            return (Criteria) this;
        }

        public Criteria andOperateplatformIsNotNull() {
            addCriterion("operatePlatform is not null");
            return (Criteria) this;
        }

        public Criteria andOperateplatformEqualTo(String value) {
            addCriterion("operatePlatform =", value, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperateplatformNotEqualTo(String value) {
            addCriterion("operatePlatform <>", value, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperateplatformGreaterThan(String value) {
            addCriterion("operatePlatform >", value, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperateplatformGreaterThanOrEqualTo(String value) {
            addCriterion("operatePlatform >=", value, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperateplatformLessThan(String value) {
            addCriterion("operatePlatform <", value, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperateplatformLessThanOrEqualTo(String value) {
            addCriterion("operatePlatform <=", value, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperateplatformLike(String value) {
            addCriterion("operatePlatform like", value, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperateplatformNotLike(String value) {
            addCriterion("operatePlatform not like", value, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperateplatformIn(List<String> values) {
            addCriterion("operatePlatform in", values, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperateplatformNotIn(List<String> values) {
            addCriterion("operatePlatform not in", values, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperateplatformBetween(String value1, String value2) {
            addCriterion("operatePlatform between", value1, value2, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperateplatformNotBetween(String value1, String value2) {
            addCriterion("operatePlatform not between", value1, value2, "operateplatform");
            return (Criteria) this;
        }

        public Criteria andOperatetypeIsNull() {
            addCriterion("operateType is null");
            return (Criteria) this;
        }

        public Criteria andOperatetypeIsNotNull() {
            addCriterion("operateType is not null");
            return (Criteria) this;
        }

        public Criteria andOperatetypeEqualTo(Integer value) {
            addCriterion("operateType =", value, "operatetype");
            return (Criteria) this;
        }

        public Criteria andOperatetypeNotEqualTo(Integer value) {
            addCriterion("operateType <>", value, "operatetype");
            return (Criteria) this;
        }

        public Criteria andOperatetypeGreaterThan(Integer value) {
            addCriterion("operateType >", value, "operatetype");
            return (Criteria) this;
        }

        public Criteria andOperatetypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("operateType >=", value, "operatetype");
            return (Criteria) this;
        }

        public Criteria andOperatetypeLessThan(Integer value) {
            addCriterion("operateType <", value, "operatetype");
            return (Criteria) this;
        }

        public Criteria andOperatetypeLessThanOrEqualTo(Integer value) {
            addCriterion("operateType <=", value, "operatetype");
            return (Criteria) this;
        }

        public Criteria andOperatetypeIn(List<Integer> values) {
            addCriterion("operateType in", values, "operatetype");
            return (Criteria) this;
        }

        public Criteria andOperatetypeNotIn(List<Integer> values) {
            addCriterion("operateType not in", values, "operatetype");
            return (Criteria) this;
        }

        public Criteria andOperatetypeBetween(Integer value1, Integer value2) {
            addCriterion("operateType between", value1, value2, "operatetype");
            return (Criteria) this;
        }

        public Criteria andOperatetypeNotBetween(Integer value1, Integer value2) {
            addCriterion("operateType not between", value1, value2, "operatetype");
            return (Criteria) this;
        }

        public Criteria andOperatequantityIsNull() {
            addCriterion("operateQuantity is null");
            return (Criteria) this;
        }

        public Criteria andOperatequantityIsNotNull() {
            addCriterion("operateQuantity is not null");
            return (Criteria) this;
        }

        public Criteria andOperatequantityEqualTo(Integer value) {
            addCriterion("operateQuantity =", value, "operatequantity");
            return (Criteria) this;
        }

        public Criteria andOperatequantityNotEqualTo(Integer value) {
            addCriterion("operateQuantity <>", value, "operatequantity");
            return (Criteria) this;
        }

        public Criteria andOperatequantityGreaterThan(Integer value) {
            addCriterion("operateQuantity >", value, "operatequantity");
            return (Criteria) this;
        }

        public Criteria andOperatequantityGreaterThanOrEqualTo(Integer value) {
            addCriterion("operateQuantity >=", value, "operatequantity");
            return (Criteria) this;
        }

        public Criteria andOperatequantityLessThan(Integer value) {
            addCriterion("operateQuantity <", value, "operatequantity");
            return (Criteria) this;
        }

        public Criteria andOperatequantityLessThanOrEqualTo(Integer value) {
            addCriterion("operateQuantity <=", value, "operatequantity");
            return (Criteria) this;
        }

        public Criteria andOperatequantityIn(List<Integer> values) {
            addCriterion("operateQuantity in", values, "operatequantity");
            return (Criteria) this;
        }

        public Criteria andOperatequantityNotIn(List<Integer> values) {
            addCriterion("operateQuantity not in", values, "operatequantity");
            return (Criteria) this;
        }

        public Criteria andOperatequantityBetween(Integer value1, Integer value2) {
            addCriterion("operateQuantity between", value1, value2, "operatequantity");
            return (Criteria) this;
        }

        public Criteria andOperatequantityNotBetween(Integer value1, Integer value2) {
            addCriterion("operateQuantity not between", value1, value2, "operatequantity");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseIsNull() {
            addCriterion("sourceWareHouse is null");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseIsNotNull() {
            addCriterion("sourceWareHouse is not null");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseEqualTo(String value) {
            addCriterion("sourceWareHouse =", value, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseNotEqualTo(String value) {
            addCriterion("sourceWareHouse <>", value, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseGreaterThan(String value) {
            addCriterion("sourceWareHouse >", value, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseGreaterThanOrEqualTo(String value) {
            addCriterion("sourceWareHouse >=", value, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseLessThan(String value) {
            addCriterion("sourceWareHouse <", value, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseLessThanOrEqualTo(String value) {
            addCriterion("sourceWareHouse <=", value, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseLike(String value) {
            addCriterion("sourceWareHouse like", value, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseNotLike(String value) {
            addCriterion("sourceWareHouse not like", value, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseIn(List<String> values) {
            addCriterion("sourceWareHouse in", values, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseNotIn(List<String> values) {
            addCriterion("sourceWareHouse not in", values, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseBetween(String value1, String value2) {
            addCriterion("sourceWareHouse between", value1, value2, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andSourcewarehouseNotBetween(String value1, String value2) {
            addCriterion("sourceWareHouse not between", value1, value2, "sourcewarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseIsNull() {
            addCriterion("targetWareHouse is null");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseIsNotNull() {
            addCriterion("targetWareHouse is not null");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseEqualTo(String value) {
            addCriterion("targetWareHouse =", value, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseNotEqualTo(String value) {
            addCriterion("targetWareHouse <>", value, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseGreaterThan(String value) {
            addCriterion("targetWareHouse >", value, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseGreaterThanOrEqualTo(String value) {
            addCriterion("targetWareHouse >=", value, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseLessThan(String value) {
            addCriterion("targetWareHouse <", value, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseLessThanOrEqualTo(String value) {
            addCriterion("targetWareHouse <=", value, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseLike(String value) {
            addCriterion("targetWareHouse like", value, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseNotLike(String value) {
            addCriterion("targetWareHouse not like", value, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseIn(List<String> values) {
            addCriterion("targetWareHouse in", values, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseNotIn(List<String> values) {
            addCriterion("targetWareHouse not in", values, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseBetween(String value1, String value2) {
            addCriterion("targetWareHouse between", value1, value2, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andTargetwarehouseNotBetween(String value1, String value2) {
            addCriterion("targetWareHouse not between", value1, value2, "targetwarehouse");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreateuseridIsNull() {
            addCriterion("createUserId is null");
            return (Criteria) this;
        }

        public Criteria andCreateuseridIsNotNull() {
            addCriterion("createUserId is not null");
            return (Criteria) this;
        }

        public Criteria andCreateuseridEqualTo(String value) {
            addCriterion("createUserId =", value, "createuserid");
            return (Criteria) this;
        }

        public Criteria andCreateuseridNotEqualTo(String value) {
            addCriterion("createUserId <>", value, "createuserid");
            return (Criteria) this;
        }

        public Criteria andCreateuseridGreaterThan(String value) {
            addCriterion("createUserId >", value, "createuserid");
            return (Criteria) this;
        }

        public Criteria andCreateuseridGreaterThanOrEqualTo(String value) {
            addCriterion("createUserId >=", value, "createuserid");
            return (Criteria) this;
        }

        public Criteria andCreateuseridLessThan(String value) {
            addCriterion("createUserId <", value, "createuserid");
            return (Criteria) this;
        }

        public Criteria andCreateuseridLessThanOrEqualTo(String value) {
            addCriterion("createUserId <=", value, "createuserid");
            return (Criteria) this;
        }

        public Criteria andCreateuseridLike(String value) {
            addCriterion("createUserId like", value, "createuserid");
            return (Criteria) this;
        }

        public Criteria andCreateuseridNotLike(String value) {
            addCriterion("createUserId not like", value, "createuserid");
            return (Criteria) this;
        }

        public Criteria andCreateuseridIn(List<String> values) {
            addCriterion("createUserId in", values, "createuserid");
            return (Criteria) this;
        }

        public Criteria andCreateuseridNotIn(List<String> values) {
            addCriterion("createUserId not in", values, "createuserid");
            return (Criteria) this;
        }

        public Criteria andCreateuseridBetween(String value1, String value2) {
            addCriterion("createUserId between", value1, value2, "createuserid");
            return (Criteria) this;
        }

        public Criteria andCreateuseridNotBetween(String value1, String value2) {
            addCriterion("createUserId not between", value1, value2, "createuserid");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeIsNull() {
            addCriterion("logisticFee is null");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeIsNotNull() {
            addCriterion("logisticFee is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeEqualTo(Integer value) {
            addCriterion("logisticFee =", value, "logisticfee");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeNotEqualTo(Integer value) {
            addCriterion("logisticFee <>", value, "logisticfee");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeGreaterThan(Integer value) {
            addCriterion("logisticFee >", value, "logisticfee");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("logisticFee >=", value, "logisticfee");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeLessThan(Integer value) {
            addCriterion("logisticFee <", value, "logisticfee");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeLessThanOrEqualTo(Integer value) {
            addCriterion("logisticFee <=", value, "logisticfee");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeIn(List<Integer> values) {
            addCriterion("logisticFee in", values, "logisticfee");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeNotIn(List<Integer> values) {
            addCriterion("logisticFee not in", values, "logisticfee");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeBetween(Integer value1, Integer value2) {
            addCriterion("logisticFee between", value1, value2, "logisticfee");
            return (Criteria) this;
        }

        public Criteria andLogisticfeeNotBetween(Integer value1, Integer value2) {
            addCriterion("logisticFee not between", value1, value2, "logisticfee");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeIsNull() {
            addCriterion("packagingFee is null");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeIsNotNull() {
            addCriterion("packagingFee is not null");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeEqualTo(Integer value) {
            addCriterion("packagingFee =", value, "packagingfee");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeNotEqualTo(Integer value) {
            addCriterion("packagingFee <>", value, "packagingfee");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeGreaterThan(Integer value) {
            addCriterion("packagingFee >", value, "packagingfee");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("packagingFee >=", value, "packagingfee");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeLessThan(Integer value) {
            addCriterion("packagingFee <", value, "packagingfee");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeLessThanOrEqualTo(Integer value) {
            addCriterion("packagingFee <=", value, "packagingfee");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeIn(List<Integer> values) {
            addCriterion("packagingFee in", values, "packagingfee");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeNotIn(List<Integer> values) {
            addCriterion("packagingFee not in", values, "packagingfee");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeBetween(Integer value1, Integer value2) {
            addCriterion("packagingFee between", value1, value2, "packagingfee");
            return (Criteria) this;
        }

        public Criteria andPackagingfeeNotBetween(Integer value1, Integer value2) {
            addCriterion("packagingFee not between", value1, value2, "packagingfee");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIsNull() {
            addCriterion("purchasePrice is null");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIsNotNull() {
            addCriterion("purchasePrice is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceEqualTo(Integer value) {
            addCriterion("purchasePrice =", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotEqualTo(Integer value) {
            addCriterion("purchasePrice <>", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceGreaterThan(Integer value) {
            addCriterion("purchasePrice >", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("purchasePrice >=", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceLessThan(Integer value) {
            addCriterion("purchasePrice <", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceLessThanOrEqualTo(Integer value) {
            addCriterion("purchasePrice <=", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIn(List<Integer> values) {
            addCriterion("purchasePrice in", values, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotIn(List<Integer> values) {
            addCriterion("purchasePrice not in", values, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceBetween(Integer value1, Integer value2) {
            addCriterion("purchasePrice between", value1, value2, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotBetween(Integer value1, Integer value2) {
            addCriterion("purchasePrice not between", value1, value2, "purchaseprice");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}